| 1. | After an execution plan is generated , it stays in the procedure cache
生成执行计划后，它处于过程缓存中。 |
| 2. | Number of pages in the procedure cache that are currently allocated to this process
当前为此进程分配的过程缓存中的页数。 |
| 3. | The lazywriter process periodically scans the list of objects in the procedure cache
惰性写入器进程定期扫描过程缓存中的对象列表。 |
| 4. | The part of the memory pool that is used to store execution plans is referred to as the procedure cache
内存池中用于存储执行计划的部分称为过程缓存。 |
| 5. | The age of our sample query plan is decremented to 0 after 16 scans of the procedure cache , unless another user references the plan
在本例中，查询计划的年经过16次过程缓存扫描后减为0 ，除非其他用户引用了该计划。 |
| 6. | If there are any execution plans in the procedure cache that reference the table , alter table marks them to be recompiled on their next execution
如果过程缓存中存在引用表的执行计划， alter table会将这些执行计划标记为下次执行时重新编译。 |
| 7. | When any sql statement is executed in sql server 2005 , the relational engine first looks through the procedure cache to verify that an existing execution plan for the same sql statement exists
在sql server 2005中执行任何sql语句时，关系引擎将首先查看过程缓存中是否有用于同一sql语句的现有执行计划。 |
